Optimizing Query Planning with Limited Source Capabilities in the Presence of Inclusion and Functional Dependencies

نویسندگان

  • Andrea Calì
  • Diego Calvanese
چکیده

Information Integration is the problem of providing a uniform access to multiple and heterogeneous data sources. The most common approach to this problem, called Globalas-View, consists in providing a global schema of data in which each relation of such a schema is defined as a view over a set of data sources. Recent works deal with this problem in the case of limited source capabilities, where in general sources can only be accessed respecting certain binding patterns for their attributes. In this case, computing the answer to a query over the global schema cannot be done by simply unfolding the global relations with their definitions. Instead, it may require the evaluation of a suitable recursive datalog program. In this paper we study query evaluation in the Global-as-View approach with limited source capabilities in the presence of full inclusion and functional dependencies between sources. We present a polynomial time algorithm for implication of such kind of dependencies and we study how the presence of such dependencies enables one to minimize the number of accesses to the sources. We provide necessary and sufficient conditions for determining whether, during query evaluation, a given source has to be accessed or not.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Optimized Querying of Integrated Data over the Web

Information Integration is the problem of providing a uniform access to multiple and heterogeneous data sources. The most common approach to this task, called global-as-view, consists in providing a global schema of the data, in which each relation is defined as a view over a set of data sources. Recent works deal with this problem in the case of limited source capabilities, where, in general, ...

متن کامل

Dynamic Query Optimization under Access Limitations and Dependencies

Unlike relational tables in a database, data sources on the Web typically can only be accessed in limited ways. In particular, some of the source fields may be required as input and thus need to be mandatorily filled in order to access the source. Answering queries over sources with access limitations is a complex task that requires a possibly recursive evaluation even when the query is non-rec...

متن کامل

Query Folding with Inclusion Dependencies

Query folding is a technique for determining how a query may be answered using a given set of resources, which may include materialized views, cached results of previous queries, or queries answerable by other databases. The power of query folding can be considerably enhanced by taking into account integrity constraints that are known to hold on base relations. This paper describes an extension...

متن کامل

مدل جدیدی برای جستجوی عبارت بر اساس کمینه جابه‌جایی وزن‌دار

Finding high-quality web pages is one of the most important tasks of search engines. The relevance between the documents found and the query searched depends on the user observation and increases the complexity of ranking algorithms. The other issue is that users often explore just the first 10 to 20 results while millions of pages related to a query may exist. So search engines have to use sui...

متن کامل

Query Planning and Optimization in Information Integration

Information integration systems, also knows as mediators, information brokers, or information gathering agents, provide uniform user interfaces to varieties of di erent information sources. With corporate databases getting connected by intranets, and vast amounts of information becoming available over the Internet, the need for information integration systems is increasing steadily. Our work fo...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2001